
1023
SELECT/UPDATE, 419
SELECT queries, 418
SQL statement, 421, 422
transactional-contexts, 410
versioned optimistic locking, 409
Query plan cache, 773, 774
R
READ_COMMITTED isolation level, 963
READ_ONLY caching, 471, 1001
Read-only mode, Author entity, 149–151
Read-through strategy, 1000
READ_UNCOMMITTED isolation
level, 961
READ_WRITE, 1001, 1002
Read-write mode, Author entity, 148, 149
read-your-writes scenario, 990
Redundant save() Calls, 685, 686
Regular Unidirectional @OneToMany
author and books persisting, 10, 11
first book, deletion, 14, 15
last book, deletion, 13, 14
new book persisting, 12, 13
REPEATABLE_READ isolation level, 964
Repository Interface, @Transactional
add, service-method level (see
Service-Method level)
callFindByIdMethodAndUpdate()
method, 428
long-running task, 429, 430
@Retry, 430
transaction boundaries, 429
cascading, 428
delay connection
AuthorRepository, 425
BookstoreService, 423, 425
computeRoyalties() method, 426
fetchByName() method, 425
service-level, 422
service-method, 425
preparation, 431
query-methods (see Query-methods)
service-method roll back, 426, 427
solution, moving, 416, 417
transaction duration, 431
transaction throughput, 404
REQUIRED propagation, 967–969
REQUIRES_NEW propagation, 970–973
rewriteBatchedStatements, 298
RIGHT JOIN statements, 272
ROW_NUMBER() window function,
665, 666, 751
ORDER BY clause, 751–753
OVER clause, 751, 754, 755
S
save() method, 791
saveAll() built-in method, 439
saveAll(Iterable<S> entities)
method, 302, 303
saveInBatch(Iterable<S> entities)
method, 303
Schemas
quickest Flyway setup, 601, 602
generate database, schema-∗.sql,
606, 608
springboot flyway (see Flyway)
Second level cache, 999
region inspect, 1000
row-level data format, 1000
strategies, 1000
SELECT COUNT subquery
native query/JPQL, 628
Page<dto>
Index